UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uv97oV0cBAWUVhSSnbVe9tk5ThuauHY9CFq8taI6LW4='
WHERE
key_id = 'c9dcc8d5dfe1ac4408ea4764c03c2dd2ee2fb04201323f1e1599e5a5bee19294'
AND (
token = 'Uv97oV0cBAWUVhSSnbVe9tk5ThuauHY9CFq8taI6LW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)