UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxBXBc2W/B+Ag5v22BHOn4WSoph59XwfE17KilYGlGA='
WHERE
key_id = '40d3e6c89ec451a39f00a28aa119c5061280d50b399c92399eabb0502ce8bfae'
AND (
token = 'IxBXBc2W/B+Ag5v22BHOn4WSoph59XwfE17KilYGlGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)