UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sh6GnuxNY4j4IQiSoeMMdTXeN9Z0BNxFJRR7KwQiMso='
WHERE
key_id = 'f7ff5f8a442ebb417af70dcca0fcc623267d1aabafa3b0548cf27c2456b9f43a'
AND (
token = 'sh6GnuxNY4j4IQiSoeMMdTXeN9Z0BNxFJRR7KwQiMso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)