UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rFB27EURojA1EddrlzDfEbmnj/I6pfNORHmkY12FJmA='
WHERE
key_id = 'b052de7138b58ccd5d180d0f9d0dddd43c25527e5c1fd9e96e30548c61ca8cc2'
AND (
token = 'rFB27EURojA1EddrlzDfEbmnj/I6pfNORHmkY12FJmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)