UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'k7TmsyzWXo81eIyAXJ45xBLRlRRyY+Ga9j/SogRpV0A=' 
WHERE 
  key_id = '8a5d825190d20a1ff2fa0763ea33a295e92d930a6e7b5e4aa5ab011e0f48e892' 
  AND (
    token = 'k7TmsyzWXo81eIyAXJ45xBLRlRRyY+Ga9j/SogRpV0A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030