UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fks5R9v3J1Xjc40x38uPTEa3NcF1hx92seB1KjzBi4I=' 
WHERE 
  key_id = 'e250a6ec0ed61246906b2ad81f44781c03a44827e0b924266b2ac489893c4f4a' 
  AND (
    token = 'fks5R9v3J1Xjc40x38uPTEa3NcF1hx92seB1KjzBi4I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033