UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1A6bsGhEGby9tc/l2mgd6mM8aRt/KFuzg+eUQxYDSA='
WHERE
key_id = 'b62b87b5a89a2e0e0856f4ece9e1bbae83ff0e7fe577c41e2768044f824a1ed2'
AND (
token = 'x1A6bsGhEGby9tc/l2mgd6mM8aRt/KFuzg+eUQxYDSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)