UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FoydY5CZ6ZdZki7V4WS1iwWGBcIYgZK8PV/JFUj5Akc='
WHERE
key_id = 'd48090c5af4171ec940b4b49f96f1549892deca22ecc8371d062b89fc0268177'
AND (
token = 'FoydY5CZ6ZdZki7V4WS1iwWGBcIYgZK8PV/JFUj5Akc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)