UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT7ymX6Jo9oqXcyK/gvNL/U34OmlXvffXvUeMA6F8L4='
WHERE
key_id = '3cf89ca6566360a214cff78a68ecd6256d36f1dd03fc653f3432533e45a658da'
AND (
token = 'XT7ymX6Jo9oqXcyK/gvNL/U34OmlXvffXvUeMA6F8L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)