UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fC7/vDnzFQnMDfaA8w3mLFrYbyq5PiFARv9F3uBkLZk='
WHERE
key_id = 'd971e10f084a08ed0d8967aeb0809d19a1ad5f21fc6634032ffac8824e2a669e'
AND (
token = 'fC7/vDnzFQnMDfaA8w3mLFrYbyq5PiFARv9F3uBkLZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)