UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKZSmFLPE8/epm6djxdyx9lLo/mj30lWyu0zapJ+rcw='
WHERE
key_id = 'ab50ceacb08f937203f04c583ec32603029ced7b6b49cd12117ca1e45c5822dc'
AND (
token = 'XKZSmFLPE8/epm6djxdyx9lLo/mj30lWyu0zapJ+rcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)