UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uHPSJFel1IaZmMnSxXr4AZvGYZrpCDNI2QYP0f/MqzM='
WHERE
key_id = '40a13d97fdaf436f54db1181fe1cd74a506f049973c899dc323e32c3c45f1292'
AND (
token = 'uHPSJFel1IaZmMnSxXr4AZvGYZrpCDNI2QYP0f/MqzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)