UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3a+kN3fZ9UyrJEcHbF499bOhSbiA9ighl5OwwaC/HpU='
WHERE
key_id = '80b0db4650481d92234f13b0e6533ad9cfbb8039b50afef660a34846c286a655'
AND (
token = '3a+kN3fZ9UyrJEcHbF499bOhSbiA9ighl5OwwaC/HpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)