UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JknSGZ6BLoRH/Nrsl7kGPgT4qWi12k/vB2ZwEM9aahw=' 
WHERE 
  key_id = '25bd125f84876b047606167c6a7bdca0b81c0f1edb315bd11c85bb2770ea48e9' 
  AND (
    token = 'JknSGZ6BLoRH/Nrsl7kGPgT4qWi12k/vB2ZwEM9aahw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021