UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yHyd/QMe4+82fTQ7lQ0fjYyfDCG1hSCIZAe9JfmPnw='
WHERE
key_id = '8bf9c11ea2696aad54972e6fc5f791a842efe939393f06ef66281b2f3b79f6de'
AND (
token = '1yHyd/QMe4+82fTQ7lQ0fjYyfDCG1hSCIZAe9JfmPnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)