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