UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q05YfjFtuOIg+YBS4owZNyP7JnDZhMN7CRA1d6+eQVg='
WHERE
key_id = 'd5452a2d8e00fc6b483ce0059e056edcc6c713593f4eddaef75545e34bde82ce'
AND (
token = 'q05YfjFtuOIg+YBS4owZNyP7JnDZhMN7CRA1d6+eQVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)