UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFEb1xdw8JY/NT3pnB16Xj9ZKcY+5sMfkKEBGyYK0l4='
WHERE
key_id = '07490f6b7cc780eaa7c83529134244a9d5a04b2807f4a1751ba248b1d6473bb2'
AND (
token = 'gFEb1xdw8JY/NT3pnB16Xj9ZKcY+5sMfkKEBGyYK0l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)