UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XObBURS5jb3Ym02+ZOL22tuSpZSYIpTeWzOfKNrs5k='
WHERE
key_id = 'cca7e14596de0a5e4004aaa69ecb41091f58d5b75e34b7b990ad9b72b2560a05'
AND (
token = '3XObBURS5jb3Ym02+ZOL22tuSpZSYIpTeWzOfKNrs5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)