UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bS1vTPOLSLVTUHAP7R/TNuU7XoDMjym591rR2HORicQ='
WHERE
key_id = '5f47716e573f234401318c146fba23023c39b05055921f9793833c58d20952d7'
AND (
token = 'bS1vTPOLSLVTUHAP7R/TNuU7XoDMjym591rR2HORicQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)