UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rE/Ro2rrVllvAFSVmanrtOXF9or72wz+H/a4o/MIjUI=' 
WHERE 
  key_id = 'adab2dc1acf35c59983a45dad065be7f624cde5ba0597bc9ae4cf86784bf3a47' 
  AND (
    token = 'rE/Ro2rrVllvAFSVmanrtOXF9or72wz+H/a4o/MIjUI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041