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