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

Query time 0.00031