UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdSw2ZBDXkGI7oSg36Rj12oO5oLO0FaiS2o/o7y5SWE='
WHERE
key_id = '8946c38e67595afc0d52ad2fef73f6e210cb7e98891f1a66761fc74d3d5f308a'
AND (
token = 'zdSw2ZBDXkGI7oSg36Rj12oO5oLO0FaiS2o/o7y5SWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)