UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yugeJqyK9Q6XOiVzGDK9sph9fIgiLAKqXw2znlLbdOY='
WHERE
key_id = '3188f003204ea2f6e5e07cf383f4b8f2c27f6e5a8e1768cc16d2a83086708bac'
AND (
token = 'yugeJqyK9Q6XOiVzGDK9sph9fIgiLAKqXw2znlLbdOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)