UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4h89uF1Xi6wd6TJGKlDNYADCoecCSdSHFYb7aFuSVlY='
WHERE
key_id = 'ca0e9a212d3616485bd429eaf75ef475b12a352ccd73b2b1096849f22de1061c'
AND (
token = '4h89uF1Xi6wd6TJGKlDNYADCoecCSdSHFYb7aFuSVlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)