UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsJ/c63XJKCBOI5a5Is6Ak7DanU3SMNB3hE63knr5FA='
WHERE
key_id = '2777d49ac1240604767a95ee6c87b5ff145f95fb8496de4c554835d95f75fd25'
AND (
token = 'gsJ/c63XJKCBOI5a5Is6Ak7DanU3SMNB3hE63knr5FA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)