UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cRhL/8WpDxGHhGPF4M8B4n2n1drbUpJdgzseuqAkyVk=' 
WHERE 
  key_id = 'c35eb41d8f725f2ec90a4bcad4af7afd605c3bc78763c00cbef56aac809ec4b5' 
  AND (
    token = 'cRhL/8WpDxGHhGPF4M8B4n2n1drbUpJdgzseuqAkyVk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047