UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I4Fw4yKGKEq6v4eP4iEggE/bcF/iLMoemqvxEB3gjiI=' 
WHERE 
  key_id = '9807e64de38c6f68a5c83e53fd1129b6d7ce98371bdb93cba132fe0e0b996601' 
  AND (
    token = 'I4Fw4yKGKEq6v4eP4iEggE/bcF/iLMoemqvxEB3gjiI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021