UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F0agc2yXSs+EZYsEaQK/d9eX0la13HRK/CUyr5RFaOU='
WHERE
key_id = '77c6ea2f59ee66d033b31e4b591b92a991382b0bdb3a63f5118b1a14dbb3994a'
AND (
token = 'F0agc2yXSs+EZYsEaQK/d9eX0la13HRK/CUyr5RFaOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)