UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Y1IpbedHctgfk45576u7PBBeP8uynBqSgWoBFnP/VU='
WHERE
key_id = '7aa7f97ebd258d0d2db61dccbe681fe4961bcbe5bb74dc35faf16ca163f9fc3b'
AND (
token = '6Y1IpbedHctgfk45576u7PBBeP8uynBqSgWoBFnP/VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)