UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vQwMvpEAadhe85L6OP4pYvlRS0cddTInJF25mIwH+jA='
WHERE
key_id = '9b9f3cb9fa71575ca09604f42f99807fb3928d86076b378250140a2fc87d4697'
AND (
token = 'vQwMvpEAadhe85L6OP4pYvlRS0cddTInJF25mIwH+jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)