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