UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n9s3s1IrF9HuChvrjKnY7G32ngv6PZT7U9eW8iEKikM='
WHERE
key_id = '54a50305b6d3225260655b93f25c553f0c9d20987df3ae7cb3eafd8307f1ad1d'
AND (
token = 'n9s3s1IrF9HuChvrjKnY7G32ngv6PZT7U9eW8iEKikM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)