UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COzjXAyCxp+AhlFJDmkTu03E0TcnRm3fwk1u9Zn5nBM='
WHERE
key_id = 'fef0ae7d83ec2cbe9e5aa40232c72071463f6fd1fb83604aaa0f96831f888405'
AND (
token = 'COzjXAyCxp+AhlFJDmkTu03E0TcnRm3fwk1u9Zn5nBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)