UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GDZ540xShwEGCRllAVuM5h7rh7zTNJ/ptk8nZny0C8Q='
WHERE
key_id = '0f7662d8e78583e00fea48358f799c5941230e179ed58112293fc25754deb0f1'
AND (
token = 'GDZ540xShwEGCRllAVuM5h7rh7zTNJ/ptk8nZny0C8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)