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