UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iN4PEg4YadYgsR49Z2PtAYs8y25jOSqImJTqkyNdxeY='
WHERE
key_id = 'a3ad93e282e74984fd83b68e471ab0252efae2dec84d4ec2ce48fbe6bb93a95e'
AND (
token = 'iN4PEg4YadYgsR49Z2PtAYs8y25jOSqImJTqkyNdxeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)