UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9sv8FVehTjERlUqKTwRoRRvlvp9wz5ES98J73QQoQE='
WHERE
key_id = 'b5b5e8fd408b3142ff8312541b11380907063798e8c4d0e731957f68db4d3201'
AND (
token = 'S9sv8FVehTjERlUqKTwRoRRvlvp9wz5ES98J73QQoQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)