UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v50cyMZNA0nTR53KAl0tnFLz5vcclaiPMSICzuB6YTk='
WHERE
key_id = '22a9ec77d71fea95be0c4428ef2bfb25ba4a879cb46018ce06aebf7244642d94'
AND (
token = 'v50cyMZNA0nTR53KAl0tnFLz5vcclaiPMSICzuB6YTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)