UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TjPY9JlJdMObhmoAIa4Slf/yWoa/GayApqPjGm7Jiyg='
WHERE
key_id = 'a2f497a90e2fce84ca48e17a4224060a370922bec29975c9613c73302484ff32'
AND (
token = 'TjPY9JlJdMObhmoAIa4Slf/yWoa/GayApqPjGm7Jiyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)