UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nx4c685fgm4/VIQ4siGH1l4VcsUrCKY7Ks/c2nC8mcM='
WHERE
key_id = 'a412e493210691b0b68b8dd577bab3ffcaa7c19ce5ddc573e6f43e756a518a2f'
AND (
token = 'nx4c685fgm4/VIQ4siGH1l4VcsUrCKY7Ks/c2nC8mcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)